﻿using System;

namespace Aulac.Rsc.Ems
{
    /// <summary>
    /// Chứa tên Tale
    /// </summary>
    public class TableNames
    {
        public class Enum
        {
            public const string Enum_StatusReq = "Enum_StatusReq";
        }
        public const string Task_TranferDeptExam = "Task_TranferDeptExam";
        /// <summary>
        /// Item
        /// </summary>
        public const string Dm_RptList = "Dm_RptList";
        public const string Dm_RptGrp = "Dm_RptGrp";
        public const string Dm_RptParams = "Dm_RptParams";
        public const string Dm_Animals = "Dm_Animals";
        public const string Dm_MdnItems = "Dm_MdnItems";
        
        public const string Dm_MdnGrpItems = "Dm_MdnGrpItems";

        public const string Dm_MdnItemGrpTypes = "Dm_MdnItemGrpTypes";
        
        public const string MdnGrpLoaded = "MdnGrpLoaded";

        public const string MdcFile_DeptCure = "MdcFile_DeptCure";
        
        public const string HspOutNote = "HspOutNote";
        
        public const string Dm_Depts = "Dm_Depts";

        public const string Dm_DeptTypes = "Dm_DeptTypes";

        public const string Dm_CureStyles = "Dm_CureStyles";

        public const string Dm_MdnStores = "Dm_MdnStores";
        
        public const string Dm_MdnStoreTypes = "Dm_MdnStoreTypes";

        /// <summary>
        /// Doi tuong kham chua benh
        /// </summary>
        public const string Dm_RdcObj = "Dm_RdcObj";

        /// <summary>
        /// Cong thuc tinh ti le mien giam
        /// </summary>
        public const string Dm_RdcExpsnIns = "Dm_RdcExpsnIns";

        public const string Dm_ICD10 = "Dm_ICD10";

        public const string Dm_ICD_NHOM = "Dm_ICD_NHOM";

        public const string Dm_JobGroup = "Dm_JobGroup";
        
        public const string Dm_UnitAgeTypes = "Dm_UnitAgeTypes";
       
        public const string Dm_SexTypes = "Dm_SexTypes";
        /// <summary>
        /// Danh mục đơn vị tính.
        /// </summary>
        public const string Dm_UnitItem = "Dm_UnitItem";
        public const string Dm_FeeTypes = "Dm_FeeTypes";
       
        public const string Dm_MdnGrpRpt = "Dm_MdnGrpRpt";
        
        public const string Sys_TableName = "Sys_TableName";

        /// <summary>
        /// Loai nhan vien
        /// </summary>
        public const string Dm_PersonTypes = "Dm_PersonTypes";

        public const string Dm_AtbObjFnc = "Dm_AtbObjFnc";
        /// <summary>
        /// Danh muc nhan vien
        /// </summary>
        public const string Dm_Personnels = "Dm_Personnels";

        public const string Dm_Providers = "Dm_Providers";

        public const string VchRecInvHeader = "VchRecInvHeader";

        public const string VchRecInvLine = "VchRecInvLine";

        public const string MngFncStyleHeader = "MngFncStyleHeader";
        
        public const string MngFncStyleRvn = "MngFncStyleRvn";
        
        public const string MngFncStyleExp = "MngFncStyleExp";
        
        /// <summary>
        /// Nguon Quy kcb
        /// </summary>
        public const string Dm_RscFunds = "Dm_RscFunds";
        
        //nguon von KCB
        public const string Dm_RscFnc = "Dm_RscFnc";
        
        /// <summary>
        /// Doi tuong nguon von
        /// </summary>
        public const string Dm_RscObj = "Dm_RscObj";
        /// <summary>
        /// Thong tin benh an doi tuong KCB
        /// </summary>
        public const string MdcFile_PntRdcObj = "MdcFile_PntRdcObj";
        
        /// <summary>
        /// Thong tin benh nhan
        /// </summary>
        public const string MdcFile_PntInfo = "MdcFile_PntInfo";      
      
        /// <summary>
        /// Table chua thong tin chi tiet ve vien phi cua BN
        /// </summary>
        public const string VchRvnPntLine = "VchRvnPntLine";
        
        /// <summary>
        /// Table chua thong tin ve phieu Vien phi cua BN
        /// </summary>
        public const string VchRvnPntHeader = "VchRvnPntHeader";
      
        /// <summary>
        /// Table chua thong tin tai chinh ItemLine
        /// </summary>
        public const string VchRvnPntFncLine = "VchRvnPntFncLine";
        public const string VchRelsInvHeader = "VchRelsInvHeader";
        public const string VchRelsInvLine = "VchRelsInvLine";
        public const string Sys_Options = "Sys_Options";

        public const string Sys_UserInfo = "Sys_UserInfo";

        public const string Sys_UserGrp = "Sys_UserGrp";

        public const string Sys_Modules = "Sys_Modules";
        
        public const string Sys_UserGrps = "Sys_UserGrps";

        /// <summary>
        /// Thong tin kham benh
        /// </summary>
        public const string Task_PntRegExam = "Task_PntRegExam";
        /// <summary>
        /// Nhat ky kham benh ngoai tru
        /// </summary>
        public const string Task_JrnOutsideExamHeader = "Task_JrnOutsideExamHeader";
        /// <summary>
        /// Danh sach loai benh kem theo.
        /// </summary>
        public const string Task_JrnOutsideExamLine = "Task_JrnOutsideExamLine";
        /// <summary>
        /// Chua thong tin trang thai yeu cau 
        /// </summary>
        public const string Task_ReqInfo = "Task_ReqInfo";

        /// <summary>
        /// Thong tin chi tiet ket qua kham benh
        /// </summary>
        public const string MdcFile_OutsideExamLine = "MdcFile_OutsideExamLine";

        /// <summary>
        /// Ket qua kham benh
        /// </summary>
        public const string MdcFile_OutsideExamHeader = "MdcFile_OutsideExamHeader";

        public const string AcntJrnHeader = "AcntJrnHeader";

        public const string AcntJrnLine = "AcntJrnLine";

        public const string AcntAtrbObjLine = "AcntAtrbObjLine";

        public const string AcntJrnLineCsp = "AcntJrnLineCsp";

        public const string VchPaymentHeader = "VchPaymentHeader";

        public const string VchPaymentLine = "VchPaymentLine";

        public const string TableCacheUpdatePrimeCostForVch = "TableCacheUpdatePrimeCostForVch";
       
        public const string TableCacheInvJrn = "TableCacheInvJrn";

        public const string InvJrnHeader = "InvJrnHeader";

        public const string InvJrnLine = "InvJrnLine";

        public const string VchTranStoreHeader = "VchTranStoreHeader";

        /// <summary>
        /// Dm Loai dich vu
        /// </summary>
        public const string Dm_ItemSvcTypes = "Dm_ItemSvcTypes";

        public const string VchTranStoreLine = "VchTranStoreLine";

        /// <summary>
        /// Tram y te
        /// </summary>
        public const string Dm_MdcStations = "Dm_MdcStations";

        /// <summary>
        /// Dm Loai tai khoan
        /// </summary>
        public const string Dm_AcntTypes = "Dm_AcntTypes";

        /// <summary>
        /// Danh muc Tai khoan
        /// </summary>
        public const string Dm_AcntCoa = "Dm_AcntCoa";

        /// <summary>
        /// Danh muc thuoc tinh doi tuong tai khoan
        /// </summary>
        public const string Dm_AcntAtrbObj = "Dm_AcntAtrbObj";

        /// <summary>
        /// Danh muc thuoc tinh theo gioi TK
        /// </summary>
        public const string Dm_AcntAtrb = "Dm_AcntAtrb";

        /// <summary>
        /// Danh muc quan he trong gia din
        /// </summary>
        public const string Dm_Relation = "Dm_Relation";

        /// <summary>
        /// Loai Doi tuong
        /// </summary>
        public const string Dm_ObjectTypes = "Dm_ObjectTypes";

        public const string Sys_FncYears = "Sys_FncYears";

        /// <summary>
        /// Thong tin ho so benh an
        /// </summary>
        public const string MdcFile_PntExam = "MdcFile_PntExam";
        
        public const string Task_PntInHsp = "Task_PntInHsp";
        
        /// <summary>
        /// Ho so benh an dieu tri
        /// </summary>
        public const string MdcFile_PntCure = "MdcFile_PntCure";

        /// <summary>
        /// Thong tin Tai nan thuong tich cua benh nhan.
        /// </summary>
        public const string MdcFile_PntAccidentInfo = "MdcFile_PntAccidentInfo";

        /// <summary>
        /// Thanh toan ra vien
        /// </summary>
        public const string MdcFile_PayOutExam = "MdcFile_PayOutExam";

        /// <summary>
        /// Lưu thông tin nhập khoa của bệnh nhân.
        /// </summary>
        public const string Task_PntDeptIn = "Task_PntDeptIn";
        
        /// <summary>
        /// Ghi trang thai di chuyen cua BN
        /// </summary>
        public const string MdcFile_PntLog = "MdcFile_PntLog";
        /// <summary>
        /// Danh muc loai ho so benh an
        /// </summary>
        public const string Dm_MdcFileTypes = "Dm_MdcFileTypes";

        /// <summary>
        /// Table Cap thuoc cho benh nhan.
        /// </summary>
        public const string VchDrugPntHeader = "VchDrugPntHeader";
        
        public const string VchDrugPntLine = "VchDrugPntLine";

        /// <summary>
        /// Chua thong tin cap thuoc tai khoa
        /// </summary>
        public const string VchDrugDept = "VchDrugDept";

        /// <summary>
        /// Table Chi phí khác của bệnh nhân.
        /// </summary>
        public const string VchOtherFeePntHeader = "VchOtherFeePntHeader";
       
        public const string VchOtherFeePntLine = "VchOtherFeePntLine";

        /// <summary>
        /// Table Phau Thu Thuat cho benh nhan.
        /// </summary>
        public const string VchPTTPntHeader = "VchPTTPntHeader";
        public const string VchPTTPntLine = "VchPTTPntLine";

        /// <summary>
        /// Table Can Lam San
        /// </summary>
        public const string VchCLSPntHeader = "VchCLSPntHeader";
        public const string VchCLSPntLine = "VchCLSPntLine";
       
        /// <summary>
        /// Table quản lý thuốc trong khoa.
        /// </summary>
        public const string VchMngDrugInDept = "VchMngDrugInDept";
        /// <summary>
        /// Table Thong tin thuc hien cac dich vu dieu tri.(CLS, PT, TT, Other)
        /// </summary>
        public const string VchCureOfPnt = "VchCureOfPnt";


        /// <summary>
        /// Dm loai doi tuong nguoi kinh phi KCB
        /// </summary>
        public const string Dm_RscFncTypes = "Dm_RscFncTypes";

        /// <summary>
        /// Chi dan dieu tri khi ra vien
        /// </summary>
        public const string Dm_GuideTrmts = "Dm_GuideTrmts";

        /// <summary>
        /// Loai the kho
        /// </summary>
        public const string Dm_TagStoreTypes = "Dm_TagStoreTypes";

        public const string Dm_VchTypes = "Dm_VchTypes";

        public const string  Sys_CompanyInfo = "Sys_CompanyInfo";
     /// <summary>
        /// Danh muc loai dich vu.
        /// </summary>
        public const string Dm_ServiceTypes = "Dm_ServiceTypes";
        /// <summary>
        /// Danh muc chi phi  dich  vu va tieu hao.
        /// </summary>
        public const string Dm_ExpService = "Dm_ExpService";
        public const string DM_ExamStyleTypes = "DM_ExamStyleTypes";
        public const string TableCacheToUpdateAcnt = "TableCacheToUpdateAcnt";

        public const string TableCacheToUpdatePrimeCostInExc = "TableCacheToUpdatePrimeCostInExc";

        /// <summary>
        /// Danh muc benh vien
        /// </summary>
        public const string Dm_Hospital = "Dm_Hospital";

        /// <summary>
        /// Danh muc quoc gia
        /// </summary>
        public const string Dm_Countries = "Dm_Countries";

        /// <summary>
        /// Quan huyen
        /// </summary>
        public const string Dm_District = "Dm_District";

        /// <summary>
        /// Phường xã
        /// </summary>
        public const string Dm_TownWard = "Dm_TownWard";

        /// <summary>
        /// Tinh, thanh pho
        /// </summary>
        public const string Dm_Province = "Dm_Province";

        /// <summary>
        /// Dan toc
        /// </summary>
        public const string Dm_Race = "Dm_Race";

        /// <summary>
        /// Thong tin loai chuyen vien
        /// </summary>
        public const string Chk_TranHspTypes = "Chk_TranHspTypes";
        /// <summary>
        /// Thong tin loai benh
        /// </summary>
        public const string Chk_IsPain = "Chk_IsPain";
        /// <summary>
        /// Table Loai benh
        /// </summary>
        public const string Chk_PainTypes = "Chk_PainTypes";
        /// <summary>
        /// Thong tin noi gioi thieu
        /// </summary>
        public const string Chk_NGT = "Chk_NGT";
        
        /// <summary>
        /// Thong tin trang thai ra vien
        /// </summary>
        public const string Chk_Ravien = "Chk_Ravien";

        /// <summary>
        /// Thong tin ket qua dieu tri
        /// </summary>
        public const string Chk_Kqdt = "Chk_Kqdt";

        /// <summary>
        /// Thong tin xu tri ra vien
        /// </summary>
        public const string Chk_GuideTrmnt = "Chk_GuideTrmnt";

        /// <summary>
        /// Nguyên nhân
        /// </summary>
        public const string Chk_Cause = "Chk_Cause";
        
        /// <summary>
        /// Xử trí sau tai nạn
        /// </summary>
        public const string Chk_DisLateAccident = "Chk_DisLateAccident";
        
        /// <summary>
        /// Diễn biến sau tai nạn
        /// </summary>
        public const string Chk_HapLateAccident = "Chk_HapLateAccident";

        /// <summary>
        /// Địa điểm xảy ra
        /// </summary>
        public const string Chk_Location = "Chk_Location";

        /// <summary>
        /// Bộ phận bị thương
        /// </summary>
        public const string Chk_PartInjured = "Chk_PartInjured";

        /// <summary>
        /// Ngộ độc các loại
        /// </summary>
        public const string Chk_Poisoning = "Chk_Poisoning";

        /// <summary>
        /// Chuyen khoa kham benh
        /// </summary>
        public const string Task_TranDeptOsdExam = "Task_TranDeptOsdExam";
  
        /// <summary>
        /// Thong tin phi tieu hao cua BN
        /// </summary>
        public const string VchExpPntHeader = "VchExpPntHeader";

        /// <summary>
        /// Phi tieu hao kham chua benh cho BN
        /// </summary>
        public const string VchExpPntLine = "VchExpPntLine";

        /// <summary>
        /// Loai don gia dich vu KCB
        /// </summary>
        public const string Dm_PriceCostTypes = "Dm_PriceCostTypes";
        
        /// <summary>
        /// Nhom dich vu
        /// </summary>
        public const string Dm_SvcGrp = "Dm_SvcGrp";
        
        /// <summary>
        /// Loai doi tuong nguon KCB
        /// </summary>
        public const string Dm_RscObjTypes = "Dm_RscObjTypes";

        /// <summary>
        /// Danh muc nhom doi tuong mien giam theo che do BHYT
        /// </summary>
        public const string Dm_RdcObjIns = "Dm_RdcObjIns";

        /// <summary>
        /// Danh muc Loai dich vu
        /// </summary>
        public const string Dm_SvcInsTypes = "Dm_SvcInsTypes";
        

        /// <summary>
        /// Danh muc loai Mat hang
        /// </summary>
        public const string Dm_MdnItemTypes = "Dm_MdnItemTypes";

        public const string Dm_DmTypesName = "Dm_DmTypesName";

        /// <summary>
        /// Danh muc phi va chi phi cua dich vu KCB
        /// </summary>
        public const string Dm_SvcExamFeeLine = "Dm_SvcExamFeeLine";
        
        public const string Dm_SvcExamGrp = "Dm_SvcExamGrp";
        /// <summary>
        /// Danh muc dich vu KCB
        /// </summary>
        public const string Dm_SvcExam = "Dm_SvcExam";
        public const string Dm_CapAssGrp = "Dm_CapAssGrp";

        /// <summary>
        /// Yeu cau CLS
        /// </summary>
        public const string VchReqClsPntHeader = "VchReqClsPntHeader";

        public const string VchReqClsPntLine = "VchReqClsPntLine";

               public const string VchReqPttPntHeader = "VchReqPttPntHeader";
        public const string VchReqPttPntLine = "VchReqPttPntLine";
        /// <summary>
        /// Danh sach BN BHYT dang ky KCB ban dau tai BV
        /// </summary>
        public const string Dm_PntIns = "Dm_PntIns";

        /// <summary>
        /// Danh muc tai san
        /// </summary>
        public const string Dm_CapAss = "Dm_CapAss";
        public const string Dm_CapAssType = "Dm_CapAssType";
        public const string Dm_Department = "Dm_Department";
        public const string Dm_Provider = "Dm_Provider";
        public const string Dm_Staff = "Dm_Staff";
        public const string Dm_StaffType = "Dm_StaffType";
        public const string Dm_Country = "Dm_Country";
        public const string Dm_SexStaff = "Dm_SexStaff";
        public const string Dm_VchBuyList = "Dm_VchBuyList";


    }

    public class ViewTableNames
    {

        public const string View_Task_JrnOutsideExam = "View_Task_JrnOutsideExam";

        public const string View_ObjectItems = "View_ObjectItems";

        public const string View_PatientInfo = "View_PatientInfo";
        
        public const string View_VchPayment = "View_VchPayment";
        
        public const string View_Task_ReqInfo = "View_Task_ReqInfo";
        
        public const string View_VchMngDrugPnt = "View_VchMngDrugPnt";
        
        public const string View_VchToaDrugPnt = "View_VchToaDrugPnt";
        
        public const string View_VchPTTPnt = "View_VchPTTPnt";
        
        public const string View_VchCLSPnt = "View_VchCLSPnt";
        
        public const string View_VchCPKPnt = "View_VchCPKPnt";

        public const string View_MdnItemAndGrp = "View_MdnItemAndGrp";


}
    
    public class SPNames
    {
  
        /// <summary>
        /// Dong bo gia tri TK theo BN
        /// Param:
        /// @VchDate Datetime , @AcntID nvarchar(20), @MdcFilePrkID decimal, @IsCredit tinyint
        /// </summary>
        public const string SP_SyncAcntJrnByPnt = "SP_SyncAcntJrnByPnt";

        /// <summary>
        /// Dong bo TK 
        /// param: @VchDate DateTime , @AcntID nvarchar(20), @IsCredit tinyint) 	
        /// </summary>
        public const string SP_SyncAcntJrn = "SP_SyncAcntJrn";

        /// <summary>
        /// Split mot chuoi thanh cac gia tri duoc luu trong Table
        /// param: @param1:Chuoi can Split, @param2: ky tu split
        /// Table: Fiel1: Id, Field2: Data
        /// </summary>
        public const string FN_SplitString = "FN_SplitString";

        public const string SP_SynInvJournalCurrentAvg = "SP_SynInvJournalCurrentAvg";

        /// <summary>
        /// Query lay Table de Calc AcntRvnJrn
        /// param: @VchOrgID, @VchOrgTypeID
        /// return: Table
        /// Field: RvnPntPrkID, VchNo, VchDate, VchName, PntPrkID, HspInNum, MdcFilePrkID, DeptPfmPrkID, 
        ///         DeptReqPrkID, DoctorPfmPrkID, DoctorReqPrkID, VchOrgID, VchOrgTypeID, ModeTrmtID, 
        ///         FncStylePrkID, PriceCostTypeID, RscFncPrkID, RscFundsPrkID, AcntRvnID, 
        ///         AcntExpID, RscObjExpPrkID, RscObjFncPrkID,ItemPrkID, StorePrkID, Quantity, AmtLineInExc
        /// </summary>
        public const string SP_GetRvnLineToCalcAcntJrn = "SP_GetRvnLineToCalcAcntJrn";

        public class tagFiedSp
        {
            public const string Id = "Id";
            public const string Data = "Data";
        }

    }

    public enum TableTypes { Table = 1, View = 2 }

}
